﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace Model
{
   public class ClassDAO
    {
        public static DataTable GetDataClass()
        {
            SqlCommand cmd = new SqlCommand("SELECT Malop, Tenlop FROM Lop", Class_Connection.conn);
            SqlDataAdapter daClass = new SqlDataAdapter(cmd);
            daClass.SelectCommand = cmd;
            DataSet ds = new DataSet();
            daClass.Fill(ds);
            return ds.Tables[0];
        }
    }
}
